Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	562100
Missing cells	40898
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	55.8 MiB
Average record size in memory	104.0 B

Variable types

Numeric	9
DateTime	1
Categorical	3

Warnings

`Exit_Reason` has constant value "AgentAnswered"	Constant
`Party_Name` has a high cardinality: 147 distinct values	High cardinality
`QueuedTime` is highly correlated with `WaitTime` and 1 other fields	High correlation
`RingTime` is highly correlated with `WaitTime vs QueuedTime`	High correlation
`WaitTime` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`Queue + Ring` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`WaitTime vs QueuedTime` is highly correlated with `RingTime`	High correlation
`channel` is highly correlated with `Exit_Reason`	High correlation
`Exit_Reason` is highly correlated with `channel`	High correlation
`HoldTime` has 24827 (4.4%) missing values	Missing
`WrapTime` has 14518 (2.6%) missing values	Missing
`WrapTime` is highly skewed (γ1 = 379.2244211)	Skewed
`df_index` has unique values	Unique
`QueuedTime` has 32969 (5.9%) zeros	Zeros
`TalkTime` has 7681 (1.4%) zeros	Zeros
`HoldTime` has 431308 (76.7%) zeros	Zeros
`WrapTime` has 10922 (1.9%) zeros	Zeros

Reproduction

Analysis started	2021-02-26 15:34:18.647385
Analysis finished	2021-02-26 15:34:58.891004
Duration	40.24 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	562100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	313042.5419
Minimum	13
Maximum	613887
Zeros	0
Zeros (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	13
5-th percentile	31238.95
Q1	164184.5
median	316289.5
Q3	465619.25
95-th percentile	584446.05
Maximum	613887
Range	613874
Interquartile range (IQR)	301434.75

Descriptive statistics

Standard deviation	176709.6527
Coefficient of variation (CV)	0.5644908567
Kurtosis	-1.175729032
Mean	313042.5419
Median Absolute Deviation (MAD)	150688
Skewness	-0.05459428694
Sum	1.759612128 × 10¹¹
Variance	3.122630135 × 10¹⁰
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4098	1	< 0.1%
99173	1	< 0.1%
23390	1	< 0.1%
21343	1	< 0.1%
107361	1	< 0.1%
113506	1	< 0.1%
111459	1	< 0.1%
101220	1	< 0.1%
105318	1	< 0.1%
60232	1	< 0.1%
Other values (562090)	562090	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13	1	< 0.1%
14	1	< 0.1%
16	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
613887	1	< 0.1%
613886	1	< 0.1%
613884	1	< 0.1%
613883	1	< 0.1%
613882	1	< 0.1%

Call_Start
Date

Distinct	548342
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Minimum	2020-01-02 08:00:21.000001
Maximum	2021-02-21 12:24:08.999997

Histogram

Histogram with fixed size bins (bins=50)

Exit_Reason
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

AgentAnswered	562100

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	7307300
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AgentAnswered
2nd row	AgentAnswered
3rd row	AgentAnswered
4th row	AgentAnswered
5th row	AgentAnswered

Value	Count	Frequency (%)
AgentAnswered	562100	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
agentanswered	562100	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	1686300	23.1%
A	1124200	15.4%
n	1124200	15.4%
g	562100	7.7%
t	562100	7.7%
s	562100	7.7%
w	562100	7.7%
r	562100	7.7%
d	562100	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6183100	84.6%
Uppercase Letter	1124200	15.4%

Most frequent character per category

Value	Count	Frequency (%)
e	1686300	27.3%
n	1124200	18.2%
g	562100	9.1%
t	562100	9.1%
s	562100	9.1%
w	562100	9.1%
r	562100	9.1%
d	562100	9.1%

Value	Count	Frequency (%)
A	1124200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7307300	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	1686300	23.1%
A	1124200	15.4%
n	1124200	15.4%
g	562100	7.7%
t	562100	7.7%
s	562100	7.7%
w	562100	7.7%
r	562100	7.7%
d	562100	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7307300	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1686300	23.1%
A	1124200	15.4%
n	1124200	15.4%
g	562100	7.7%
t	562100	7.7%
s	562100	7.7%
w	562100	7.7%
r	562100	7.7%
d	562100	7.7%

Party_Name
Categorical

HIGH CARDINALITY

Distinct	147
Distinct (%)	< 0.1%
Missing	16
Missing (%)	< 0.1%
Memory size	4.3 MiB

Alex Dillon	16744
Daniel Schirmer	13918
Dave Lee Wincek	13590
John Gene Vura	13257
Alex Baltas	12996
Other values (142)	491579

Length

Max length	17
Median length	16
Mean length	15.37884017
Min length	8

Characters and Unicode

Total characters	8644200
Distinct characters	51
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kyle Younglas
2nd row	Luis Torres
3rd row	Daniel Schirmer
4th row	Mike Bilfield
5th row	Chris Smucny

Value	Count	Frequency (%)
Alex Dillon	16744	3.0%
Daniel Schirmer	13918	2.5%
Dave Lee Wincek	13590	2.4%
John Gene Vura	13257	2.4%
Alex Baltas	12996	2.3%
Timmy Moran	12857	2.3%
Butch Herten	12424	2.2%
Mike Pascaru	12390	2.2%
Dustin Pollock	11732	2.1%
Dan Terbrack	11386	2.0%
Other values (137)	430790	76.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
alex	58681	5.1%
mike	46134	4.0%
john	26111	2.3%
matt	22635	2.0%
dan	22432	1.9%
dillon	20301	1.8%
joe	19642	1.7%
connor	18112	1.6%
daniel	16419	1.4%
schirmer	16418	1.4%
Other values (146)	884130	76.8%

Most occurring characters

Value	Count	Frequency (%)
	2222207	25.7%
e	724093	8.4%
a	580071	6.7%
n	516805	6.0%
r	445569	5.2%
l	403147	4.7%
o	371993	4.3%
i	370230	4.3%
t	258391	3.0%
c	191036	2.2%
Other values (41)	2560658	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5249661	60.7%
Space Separator	2222207	25.7%
Uppercase Letter	1171922	13.6%
Other Punctuation	410	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	724093	13.8%
a	580071	11.0%
n	516805	9.8%
r	445569	8.5%
l	403147	7.7%
o	371993	7.1%
i	370230	7.1%
t	258391	4.9%
c	191036	3.6%
h	190793	3.6%
Other values (15)	1197533	22.8%

Value	Count	Frequency (%)
M	159310	13.6%
S	105566	9.0%
D	104942	9.0%
B	101363	8.6%
A	95994	8.2%
C	93139	7.9%
J	80590	6.9%
T	65411	5.6%
K	65282	5.6%
L	40930	3.5%
Other values (14)	259395	22.1%

Value	Count	Frequency (%)
	2222207	100.0%

Value	Count	Frequency (%)
*	410	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6421583	74.3%
Common	2222617	25.7%

Most frequent character per script

Value	Count	Frequency (%)
e	724093	11.3%
a	580071	9.0%
n	516805	8.0%
r	445569	6.9%
l	403147	6.3%
o	371993	5.8%
i	370230	5.8%
t	258391	4.0%
c	191036	3.0%
h	190793	3.0%
Other values (39)	2369455	36.9%

Value	Count	Frequency (%)
	2222207	> 99.9%
*	410	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8644200	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	2222207	25.7%
e	724093	8.4%
a	580071	6.7%
n	516805	6.0%
r	445569	5.2%
l	403147	4.7%
o	371993	4.3%
i	370230	4.3%
t	258391	3.0%
c	191036	2.2%
Other values (41)	2560658	29.6%

channel
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

SEO	412579
PPC	149521

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1686300
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SEO
2nd row	SEO
3rd row	SEO
4th row	SEO
5th row	SEO

Value	Count	Frequency (%)
SEO	412579	73.4%
PPC	149521	26.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
seo	412579	73.4%
ppc	149521	26.6%

Most occurring characters

Value	Count	Frequency (%)
S	412579	24.5%
E	412579	24.5%
O	412579	24.5%
P	299042	17.7%
C	149521	8.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1686300	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	412579	24.5%
E	412579	24.5%
O	412579	24.5%
P	299042	17.7%
C	149521	8.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1686300	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	412579	24.5%
E	412579	24.5%
O	412579	24.5%
P	299042	17.7%
C	149521	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1686300	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	412579	24.5%
E	412579	24.5%
O	412579	24.5%
P	299042	17.7%
C	149521	8.9%

QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	928
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.71296389
Minimum	0
Maximum	5040
Zeros	32969
Zeros (%)	5.9%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	4
Q3	12
95-th percentile	80
Maximum	5040
Range	5040
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	49.86228817
Coefficient of variation (CV)	2.815016645
Kurtosis	552.1475594
Mean	17.71296389
Median Absolute Deviation (MAD)	2
Skewness	13.24491114
Sum	9956457
Variance	2486.247781
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	123031	21.9%
3	74225	13.2%
2	55311	9.8%
5	36214	6.4%
1	34414	6.1%
0	32969	5.9%
6	12298	2.2%
7	11041	2.0%
9	10990	2.0%
8	10560	1.9%
Other values (918)	161047	28.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	32969	5.9%
1	34414	6.1%
2	55311	9.8%
3	74225	13.2%
4	123031	21.9%

Value	Count	Frequency (%)
5040	1	< 0.1%
4938	1	< 0.1%
3190	1	< 0.1%
2750	1	< 0.1%
2417	1	< 0.1%

RingTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.032798434
Minimum	0
Maximum	29
Zeros	1769
Zeros (%)	0.3%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	7
Q3	10
95-th percentile	16
Maximum	29
Range	29
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.260604147
Coefficient of variation (CV)	0.5304009782
Kurtosis	0.486628499
Mean	8.032798434
Median Absolute Deviation (MAD)	3
Skewness	0.8183104623
Sum	4515236
Variance	18.1527477
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
6	58942	10.5%
5	56971	10.1%
7	53282	9.5%
4	52040	9.3%
8	51126	9.1%
9	44905	8.0%
10	37560	6.7%
3	36281	6.5%
11	30556	5.4%
12	24305	4.3%
Other values (20)	116132	20.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1769	0.3%
1	7842	1.4%
2	22382	4.0%
3	36281	6.5%
4	52040	9.3%

Value	Count	Frequency (%)
29	2	< 0.1%
28	2	< 0.1%
27	3	< 0.1%
26	97	< 0.1%
25	146	< 0.1%

TalkTime
Real number (ℝ_≥0)

ZEROS

Distinct	1760
Distinct (%)	0.3%
Missing	1537
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	195.5202056
Minimum	0
Maximum	5791
Zeros	7681
Zeros (%)	1.4%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	51
median	139
Q3	259
95-th percentile	610
Maximum	5791
Range	5791
Interquartile range (IQR)	208

Descriptive statistics

Standard deviation	202.2350432
Coefficient of variation (CV)	1.034343446
Kurtosis	8.570580301
Mean	195.5202056
Median Absolute Deviation (MAD)	97
Skewness	2.207121686
Sum	109601393
Variance	40899.0127
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7681	1.4%
20	4229	0.8%
19	4119	0.7%
18	4116	0.7%
21	4102	0.7%
22	3959	0.7%
17	3957	0.7%
23	3826	0.7%
24	3796	0.7%
16	3776	0.7%
Other values (1750)	517002	92.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7681	1.4%
1	1793	0.3%
2	2001	0.4%
3	1836	0.3%
4	1547	0.3%

Value	Count	Frequency (%)
5791	1	< 0.1%
3607	1	< 0.1%
3547	1	< 0.1%
3223	1	< 0.1%
3177	1	< 0.1%

HoldTime
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	636
Distinct (%)	0.1%
Missing	24827
Missing (%)	4.4%
Infinite	0
Infinite (%)	0.0%

Mean	7.814933935
Minimum	0
Maximum	1789
Zeros	431308
Zeros (%)	76.7%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	53
Maximum	1789
Range	1789
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	34.66194998
Coefficient of variation (CV)	4.435347793
Kurtosis	119.8265529
Mean	7.814933935
Median Absolute Deviation (MAD)	0
Skewness	8.272977537
Sum	4198753
Variance	1201.450777
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	431308	76.7%
1	21636	3.8%
2	10548	1.9%
3	8271	1.5%
4	5674	1.0%
5	4308	0.8%
6	3573	0.6%
7	2757	0.5%
8	2139	0.4%
9	1450	0.3%
Other values (626)	45609	8.1%
(Missing)	24827	4.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	431308	76.7%
1	21636	3.8%
2	10548	1.9%
3	8271	1.5%
4	5674	1.0%

Value	Count	Frequency (%)
1789	1	< 0.1%
1598	1	< 0.1%
1247	1	< 0.1%
1203	1	< 0.1%
1079	1	< 0.1%

WrapTime
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	2560
Distinct (%)	0.5%
Missing	14518
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%

Mean	151.5060466
Minimum	0
Maximum	227003
Zeros	10922
Zeros (%)	1.9%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	17
median	83
Q3	195
95-th percentile	525
Maximum	227003
Range	227003
Interquartile range (IQR)	178

Descriptive statistics

Standard deviation	383.5361301
Coefficient of variation (CV)	2.531490582
Kurtosis	223520.4677
Mean	151.5060466
Median Absolute Deviation (MAD)	74
Skewness	379.2244211
Sum	82961984
Variance	147099.9631
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	15006	2.7%
5	13968	2.5%
3	13454	2.4%
6	11988	2.1%
0	10922	1.9%
7	10029	1.8%
8	8851	1.6%
9	7579	1.3%
10	6829	1.2%
11	6006	1.1%
Other values (2550)	442950	78.8%
(Missing)	14518	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10922	1.9%
1	2021	0.4%
2	5679	1.0%
3	13454	2.4%
4	15006	2.7%

Value	Count	Frequency (%)
227003	1	< 0.1%
10386	1	< 0.1%
9834	1	< 0.1%
9817	1	< 0.1%
9726	1	< 0.1%

WaitTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	946
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.74576232
Minimum	0
Maximum	5051
Zeros	1303
Zeros (%)	0.2%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	13
Q3	22
95-th percentile	85
Maximum	5051
Range	5051
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	49.42966034
Coefficient of variation (CV)	1.91991442
Kurtosis	571.3819238
Mean	25.74576232
Median Absolute Deviation (MAD)	5
Skewness	13.49560162
Sum	14471693
Variance	2443.291322
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	43474	7.7%
9	40850	7.3%
12	38263	6.8%
11	37335	6.6%
8	36361	6.5%
14	31375	5.6%
13	29065	5.2%
7	26358	4.7%
16	23190	4.1%
15	20746	3.7%
Other values (936)	235083	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1303	0.2%
1	117	< 0.1%
2	276	< 0.1%
3	532	0.1%
4	4193	0.7%

Value	Count	Frequency (%)
5051	1	< 0.1%
4946	1	< 0.1%
3197	1	< 0.1%
2752	1	< 0.1%
2425	1	< 0.1%

Queue + Ring
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	946
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.74576232
Minimum	0
Maximum	5051
Zeros	1303
Zeros (%)	0.2%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	13
Q3	22
95-th percentile	85
Maximum	5051
Range	5051
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	49.42966034
Coefficient of variation (CV)	1.91991442
Kurtosis	571.3819238
Mean	25.74576232
Median Absolute Deviation (MAD)	5
Skewness	13.49560162
Sum	14471693
Variance	2443.291322
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	43474	7.7%
9	40850	7.3%
12	38263	6.8%
11	37335	6.6%
8	36361	6.5%
14	31375	5.6%
13	29065	5.2%
7	26358	4.7%
16	23190	4.1%
15	20746	3.7%
Other values (936)	235083	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1303	0.2%
1	117	< 0.1%
2	276	< 0.1%
3	532	0.1%
4	4193	0.7%

Value	Count	Frequency (%)
5051	1	< 0.1%
4946	1	< 0.1%
3197	1	< 0.1%
2752	1	< 0.1%
2425	1	< 0.1%

WaitTime vs QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.032798434
Minimum	0
Maximum	29
Zeros	1769
Zeros (%)	0.3%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	7
Q3	10
95-th percentile	16
Maximum	29
Range	29
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.260604147
Coefficient of variation (CV)	0.5304009782
Kurtosis	0.486628499
Mean	8.032798434
Median Absolute Deviation (MAD)	3
Skewness	0.8183104623
Sum	4515236
Variance	18.1527477
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
6	58942	10.5%
5	56971	10.1%
7	53282	9.5%
4	52040	9.3%
8	51126	9.1%
9	44905	8.0%
10	37560	6.7%
3	36281	6.5%
11	30556	5.4%
12	24305	4.3%
Other values (20)	116132	20.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1769	0.3%
1	7842	1.4%
2	22382	4.0%
3	36281	6.5%
4	52040	9.3%

Value	Count	Frequency (%)
29	2	< 0.1%
28	2	< 0.1%
27	3	< 0.1%
26	97	< 0.1%
25	146	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	RingTime	TalkTime	HoldTime	WrapTime	WaitTime	Queue + Ring	WaitTime vs QueuedTime
0	13	2020-01-02 08:00:21.000001	AgentAnswered	Kyle Younglas	SEO	0	9	184.0	0.0	318.0	9	9	9
1	14	2020-01-02 08:00:56.000001	AgentAnswered	Luis Torres	SEO	0	5	454.0	0.0	15.0	5	5	5
2	16	2020-01-02 08:02:52.000002	AgentAnswered	Daniel Schirmer	SEO	1	11	411.0	0.0	95.0	12	12	11
3	18	2020-01-02 08:03:16.000004	AgentAnswered	Mike Bilfield	SEO	0	6	182.0	89.0	8.0	6	6	6
4	19	2020-01-02 08:03:31.000003	AgentAnswered	Chris Smucny	SEO	1	5	428.0	0.0	35.0	6	6	5
5	20	2020-01-02 08:03:46.000002	AgentAnswered	Ian Flanagan	SEO	0	8	27.0	3.0	15.0	8	8	8
6	21	2020-01-02 08:04:21.000003	AgentAnswered	Kenneth Combes	PPC	1	9	522.0	44.0	92.0	10	10	9
7	22	2020-01-02 08:05:00.000004	AgentAnswered	Mac Blank	SEO	1	3	56.0	2.0	10.0	4	4	3
8	23	2020-01-02 08:05:38.000003	AgentAnswered	Alex Shroyer	SEO	1	15	14.0	2.0	22.0	16	16	15
9	24	2020-01-02 08:07:53.000003	AgentAnswered	Michael DiZonno	PPC	0	8	100.0	0.0	5.0	8	8	8

Last rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	RingTime	TalkTime	WrapTime	WaitTime	Queue + Ring	WaitTime vs QueuedTime
562090	613877	2021-02-21 12:05:26.999998	AgentAnswered	Johnathan Jordan	SEO	12	12	132.0	0.0	24	24	12
562091	613878	2021-02-21 12:07:37.000004	AgentAnswered	Matthew Duff	SEO	11	11	210.0	0.0	22	22	11
562092	613879	2021-02-21 12:08:27.000004	AgentAnswered	Junior Fetchet	SEO	8	8	133.0	2.0	16	16	8
562093	613880	2021-02-21 12:13:19.000001	AgentAnswered	Matt Tashjian	SEO	15	15	68.0	42.0	30	30	15
562094	613881	2021-02-21 12:13:54.000002	AgentAnswered	Matthew Duff	SEO	18	6	92.0	2.0	24	24	6
562095	613882	2021-02-21 12:14:41.999997	AgentAnswered	Lauren Basch	SEO	17	5	40.0	0.0	22	22	5
562096	613883	2021-02-21 12:17:38.999996	AgentAnswered	Matt Tashjian	SEO	14	14	121.0	2.0	28	28	14
562097	613884	2021-02-21 12:18:55.000003	AgentAnswered	Meredith Chesney	SEO	4	4	289.0	1.0	8	8	4
562098	613886	2021-02-21 12:22:32.999998	AgentAnswered	Matt Tashjian	SEO	17	17	55.0	12.0	34	34	17
562099	613887	2021-02-21 12:24:08.999997	AgentAnswered	Junior Fetchet	SEO	7	7	201.0	42.0	14	14	7

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows